Hệ thống quản lý trường học bằng PHP / MySQLi

1 <?php
2 error_reporting(
0);//turning off error reporting
3 include(
"connect.php");
4 ?>
5 <?php
6 SESSION_START();
7 ?>
8 <!DOCTYPE html>
9 <html>
10
11 <head>
12     <meta charset=
"utf-8">
13     <meta name=
"viewport" content="width=device-width, initial-scale=1.0">
14     <title>school management system</title>
15     <link rel=
"shortcut icon" href="assets/img/title.gif" type="image/x-icon">
16     <link rel=
"stylesheet" href="assets/css/bootstrap.min.css">
17     <link href=
"assets/css/loader.css" rel="stylesheet" />
18     <script src=
"assets/js/canvasjs.min.js"></script>
19     <!--*****jquery -
3.2.1.js file supports the use of dropdown***-->
20     <script src=
"assets/js/jquery-3.2.1.js"></script>
21 </head>
22
23 <body >
24 <!--end of heading section-->
25 <ul
class="nav navbar-right top-nav">
26     <div
class="dropdown">
27   <button
class="btn btn-primary dropdown-toggle" type="button" data-toggle="dropdown" >
28   <?php
29         
//Check to see if the user is logged in.if not redirect user to the loging page.
30         
31         
if(isset($_SESSION['fname']))
32         {
33         echo
"Current user: ".$_SESSION['fname']. "&nbsp;".$_SESSION['lname']. " ";
34         }
else{
35           echo
"<script type='text/javascript'>
36                     alert( 'You must Log
in to use the system');
37                     </script>"
;
38                 echo
"<script>
39                     window.location = 'index.php'
40                   </script>"
;
41         }
42         ?>
43   <span
class="caret"></span></button>
44   <ul
class="dropdown-menu">
45       <li><a href=
"manage_account.php"><i class="fa fa-users fa-lg"></i>&nbsp;View User</a></li>
46       <li><a href=
"register_form.php"><i class="fa fa-users fa-lg"></i>&nbsp;Add New User</a></li>
47       <li
class="divider"></li>
48       <li><a href=
"session_logout.php"><i class="fa fa-fw fa-power-off"></i>&nbsp;Log Out</a></li>
49   </ul>
50 </div>
51   </ul>
52 <!--************************************************-->
53 <div style=
"
54     font-family:Nyala, Arial;
55     text-align: left;
56     background-color: #526F35;
57     padding: 20px;
58     color:white;
59     width:
100%;
60     height: 150px;"
>
61     <!--This codes to load the image loader-->
62     <div id=
"loading">
63             <img id=
"loading-image" src="assets/img/loader.gif" alt="Loading..." />
64     </div>
65 <!--
this is the heading section-->
66     <h2>
67             <?php
68             $sql=
"SELECT * FROM companyinfo";
69             $result=mysqli_query($db,$sql) or die(
"error getting data");
70             $num_rows=mysqli_num_rows($result);
71              
while($row=mysqli_fetch_array($result))
72                     {
73                     echo
'<image style="height:82px; width:82px;" src="data:image;base64,'. $row['clogo'].' "> ';
74                     $cname = $row[
'cname'];
75                      $cemail = $row[
'cemail'];
76                       $ccontact = $row[
'ccontact'];
77                        $clocation = $row[
'clocation'];
78                     }?>
79                     <?php
80                     echo $cname;
81                     ?>
82
83     <div style=
"float:right; font-size:20px;text-align:right;">
84     
85     <img src=
"assets/img/mail2.png">Email: <?php echo $cemail; ?><br>
86     <img src=
"assets/img/call1.png">Contact:<?php echo $ccontact; ?><br>
87     <img src=
"assets/img/location.png">Location: <?php echo $clocation; ?>
88     
89     </div>
90    </h2>
91 </div>
92 <!--end of heading section-->
93     
94     <div>
95         <ul
class="nav nav-tabs">
96             <li ><a href=
"homepage.php" >Administration <img src="assets/img/details.png"></a></li>
97             <li ><a href=
"students.php" >Students <img src="assets/img/student48.png"></a></li>
98             <li><a href=
"staff.php">Staff Member <img src="assets/img/staff48.png"></a></li>
99             <li><a href=
"course.php" >Courses <img src="assets/img/course.png"></a></li>
100             <li><a href=
"departments.php" >Departments <img src="assets/img/department.png"></a></li>
101             <li ><a href=
"markstep1.php" >Exams <img src="assets/img/update.png"></a></li>
102             <li><a href=
"hostel.php" >Hostel <img src="assets/img/details.png"></a></li>
103             <li><a href=
"sms.php">SMS <img src="assets/img/details.png"></a></li>
104             <!--<li><a href=
"tab-8" role="tab" data-toggle="tab">Hostel <img src="assets/img/details.png"></a></li>
105             <li><a href=
"tab-7" role="tab" data-toggle="tab">Parents <img src="assets/img/details.png"></a></li>-->
106             
107         </ul>
108         <div
class="tab-content">
109             <div
class="tab-pane active" role="tabpanel" id="tab-1">
110                 
111                 <p>
112                     <div
class="table-responsive" >
113 <!--****************************************************************************-->
114                         <div
class="container" style="width:100%">
115                             
116                                 <ul
class="nav nav-tabs">
117                                   <li ><a href=
"feestudents.php">Students List<img src="assets/img/new.png"> </a></li>
118                                   <li ><a href=
"csvfee.php">Import/Export CSV<img src="assets/img/export.png"></a></li>
119                                   <li
class="active"><a href="printfeeinvoice.php">Print Invoice<img src="assets/img/print.png"> </a></li>
120                                   <li ><a href=
"view_those_who_have_paid_monthly_installment.php">View school fees<img src="assets/img/export.png"></a></li>
121                                   <li ><a href=
"fee_reports.php">Reports<img src="assets/img/print.png"> </a></li>
122                                   
123                                 </ul>
124                             <br>
125                             
126                         </div>
127   <!--*************************************************************************************************************************-->
128  
129 <h4><center><h4><strong>Generate Invoice</strong></h4></center></h4>
130          
131                 <div
class="row">
132                     <div
class="col-sm-3">
133                     </div>
134                      <div
class="col-sm-6" >
135
136
137                         <form method=
"get" action="reports_all/year_specified_invoice_per_student.php">
138                         <!--consider
using pdf.php for the entire print out of fee paid-->
139
140                                     <table cellpadding=
"0" cellspacing="0" border="0" class="table" id="example">
141                                         <tr>
142                                             <td>
143                                                 <label>Enter admission to generate invoice[This will print invoice
for the current year]</label>
144                                                 <?php
145                                                     $admission_number=$_GET[
'id'];
146
147                                                 ?>
148                                             
149                                                 <input type=
"text" name="admission_number" class="form-control" required
150                                                 
value="<?php echo $admission_number ?>">
151                                             </td>
152                                         </tr>
153                                         <tr>
154                                             <td>
155                                                 <label>Class. </label>
156                                                 <
select name="form" required class="form-control">
157                                                 <?php
158                                                 $sql2=
"SELECT * FROM course where course_id>0 and course_id<5 ";
159                                                 $records2=mysqli_query($db,$sql2);
160                                                 $
out=mysqli_num_rows($records2);
161                                                                                                       
162                                                 
//end of check process. the output is stored in variable $out
163                                                 
while($users2=mysqli_fetch_array($records2))
164                                                         {
165                                                             echo
"<option>".$users2['course_id']."</option>";
166                                                         }
167                                                 
168                                                 ?></
select>
169                                               
170                                             </td>
171                                         </tr>
172                                         
173                                         <td>Additional notes to be refrected
on the invoice (optional)
174                                             <textarea rows=
"5" name="add" class="form-control" placeholder="Additional Note">
175                                                     
176                                                 </textarea>
177                                         </td>
178                                      </tr>
179                                         
180                                         <tr>
181                                         <td><input type=
"HIDDEN" name="date" value="<?php echo date('D-M-Y') ; ?>"></td>
182                                         <tr>
183                                         
184                                         <tr>
185                                             <td><input type=
"submit" name="submit" value="Generate" ></td>
186                                         </tr>
187                                     </table>
188                                 </form>
189
190                
191 <!--****************************************************************************-->
192  
193
194                 </div>
195                 </p>
196
197             </div>
198             
199         </div>
200     </div>
201     
202     <div
class="col-md-12" style="background-color:#526F35;bottom:0px; position:fixed;">
203         <p
class="text-center text-danger" style="color:white;" >@J. Muthama Tel: +254729734768</p>
204     </div>
205     <script src=
"assets/js/jquery.min.js"></script>
206     <script src=
"assets/bootstrap/js/bootstrap.min.js"></script>
207     <script src=
"assets/js/affix.js"></script>
208     <script src=
"assets/js/alert.js"></script>
209     <script src=
"assets/js/alert1.js"></script>
210     <script src=
"assets/js/bootstrap.js"></script>
211     <script src=
"assets/js/bootstrap.min.js"></script>
212     <script src=
"assets/js/bootstrap-datepicker.js"></script>
213     <script src=
"assets/js/bootstrap-wysihtml5.js"></script>
214     <script src=
"assets/js/button.js"></script>
215     <script src=
"assets/js/carousel.js"></script>
216     <script src=
"assets/js/chosen.jquery.min.js"></script>
217     <script src=
"assets/js/ckeditor.js"></script>
218     <script src=
"assets/js/collapse.js"></script>
219     <script src=
"assets/js/color.js"></script>
220     <script src=
"assets/js/dropdown.js"></script>
221     <script src=
"assets/js/DT_bootstrap.js"></script>
222     <script src=
"assets/js/dynamic.js"></script>
223     <script src=
"assets/js/ie-emulation-modes-warning.js"></script>
224     <script src=
"assets/js/jquery.dataTables.js"></script>
225     <script src=
"assets/js/jquery.dataTables.min.js"></script>
226     <script src=
"assets/js/jquery.dialog.js"></script>
227     <script src=
"assets/js/jquery.hoverdir.js"></script>
228     <script src=
"assets/js/jquery.jgrowl.js"></script>
229     <script src=
"assets/js/jquery.knob.js"></script>
230     <script src=
"assets/js/jquery.uniform.min.js"></script>
231     <script src=
"assets/js/jquery-1.8.3.min.js"></script>
232     <script src=
"assets/js/jquery-1.9.1.js"></script>
233     <script src=
"assets/js/jquery-1.9.1.min.js"></script>
234     <script src=
"assets/js/jquery-1.10.2.js"></script>
235     <script src=
"assets/js/jquery-1.11.0.js"></script>
236     <script src=
"assets/js/jquery-ui-1.9.2.custom.min.js"></script>
237     <script src=
"assets/js/jquery-ui-1.10.3.js"></script>
238     <script src=
"assets/js/modal.js"></script>
239     <script src=
"assets/js/modernizr-2.6.2-respond-1.1.0.min.js"></script>
240     <script src=
"assets/js/myjquery.js"></script>
241     <script src=
"assets/js/myjquery1.js"></script>
242     <script src=
"assets/js/npm.js"></script>
243     <script src=
"assets/js/popover.js"></script>
244     <script src=
"assets/js/profile.js"></script>
245     <script src=
"assets/js/raphael-min.js"></script>
246     <script src=
"assets/js/sb-admin-2.js"></script>
247     <script src=
"assets/js/scripts.js"></script>
248     <script src=
"assets/js/scrollspy.js"></script>
249     <script src=
"assets/js/tab.js"></script>
250     <script src=
"assets/js/tooltip.js"></script>
251     <script src=
"assets/js/transition.js"></script>
252     <script src=
"assets/js/wysihtml5-0.3.0.js"></script>
253     <script language=
"javascript" type="text/javascript">
254      $(window).load(function()
255       {
256         $(
'#loading').hide();
257       });
258 </script>
259 </body>
260
261 </html>


Gõ tìm kiếm nhanh...